package com.isoft.demo.dao;

import com.isoft.demo.entity.Employee;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface EmployeeDao {
    @Select("select eid,ename,esalary,epost,emonth,esum from employee")
    List<Employee>searchSalary();

    @Select("select eid,ename,esalary,epost,emonth,esum from employee where eid=#{eid}")
    List<Employee>searchSalaryById(int eid);

    @Select("select * from employee where epost='司机'")
    List<Employee>searchByEpost();
    @Select("select * from employee where epost='操作员'")
    List<Employee>searchByepost();
}
